﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="METUCMTDataSet" targetNamespace="http://tempuri.org/METUCMTDataSet.xsd" xmlns:mstns="http://tempuri.org/METUCMTDataSet.xsd" xmlns="http://tempuri.org/METUCMTDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="METUCMTDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="METUCMTDBConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.METUCMTDBConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CoursesTableAdapter" GeneratorDataComponentClassName="CoursesTableAdapter" Name="Courses" UserDataComponentName="CoursesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Courses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Courses] WHERE (([CourseId] = @Original_CourseId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Courses] ([CourseCode], [CourseName], [Semester]) VALUES (@CourseCode, @CourseName, @Semester)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CourseCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CourseCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CourseName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CourseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CourseId, CourseCode, CourseName, Semester FROM dbo.Courses</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Courses] SET [CourseCode] = @CourseCode, [CourseName] = @CourseName, [Semester] = @Semester WHERE (([CourseId] = @Original_CourseId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CourseCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CourseCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CourseName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CourseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CourseId" DataSetColumn="CourseId" />
              <Mapping SourceColumn="CourseCode" DataSetColumn="CourseCode" />
              <Mapping SourceColumn="CourseName" DataSetColumn="CourseName" />
              <Mapping SourceColumn="Semester" DataSetColumn="Semester" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteCourse" Modifier="Public" Name="DeleteCourse" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteCourse">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[Courses] WHERE 
CourseId = @courseId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.Courses" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Courses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCourseId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCourseId" GeneratorSourceName="FillByCourseId" GetMethodModifier="Public" GetMethodName="GetDataByCourseId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCourseId" UserSourceName="FillByCourseId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CourseId, CourseCode, CourseName, Semester FROM dbo.Courses
where CourseId = @courseId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.Courses" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetMaxCourseId" Modifier="Public" Name="GetMaxCourseId" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetMaxCourseId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT max(CourseId) FROM Courses</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.InsertCourse" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="InsertCourse" Modifier="Public" Name="InsertCourse" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="InsertCourse">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.InsertCourse</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@courseCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@courseName" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@semester" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="InputOutput" ParameterName="@Identity" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateCourse" Modifier="Public" Name="UpdateCourse" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdateCourse">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Courses] SET [CourseCode] = @CourseCode, [CourseName] = @CourseName, [Semester] = @Semester WHERE (([CourseId] = @Original_CourseId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CourseCode" ColumnName="CourseCode" DataSourceName="METUCMTDB.dbo.Courses" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@CourseCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="CourseCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CourseName" ColumnName="CourseName" DataSourceName="METUCMTDB.dbo.Courses" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@CourseName" Precision="0" ProviderType="VarChar" Scale="0" Size="40" SourceColumn="CourseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Semester" ColumnName="Semester" DataSourceName="METUCMTDB.dbo.Courses" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="VarChar" Scale="0" Size="40" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CourseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.Courses" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_CourseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseInstructorsTableAdapter" GeneratorDataComponentClassName="CourseInstructorsTableAdapter" Name="CourseInstructors" UserDataComponentName="CourseInstructorsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.CourseInstructors" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[CourseInstructors] WHERE (([CourseInstructorId] = @Original_CourseInstructorId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseInstructorId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseInstructorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CourseInstructors] ([CourseId], [UserId]) VALUES (@CourseId, @UserId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CourseInstructorId, CourseId, UserId FROM dbo.CourseInstructors</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CourseInstructors] SET [CourseId] = @CourseId, [UserId] = @UserId WHERE (([CourseInstructorId] = @Original_CourseInstructorId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseInstructorId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseInstructorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CourseInstructorId" DataSetColumn="CourseInstructorId" />
              <Mapping SourceColumn="CourseId" DataSetColumn="CourseId" />
              <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteCourseInstructor" Modifier="Public" Name="DeleteCourseInstructor" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteCourseInstructor">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[CourseInstructors] WHERE CourseId = @courseId and UserId = @userId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.CourseInstructors" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="userId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.CourseInstructors" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.CourseInstructors" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCourseId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCourseId" GeneratorSourceName="FillByCourseId" GetMethodModifier="Public" GetMethodName="GetDataByCourseId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCourseId" UserSourceName="FillByCourseId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CourseInstructorId, CourseId, UserId FROM dbo.CourseInstructors
where CourseId = @courseId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.CourseInstructors" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.CourseInstructors" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByInstructorId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByInstructorId" GeneratorSourceName="FillByInstructorId" GetMethodModifier="Public" GetMethodName="GetDataByInstructorId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByInstructorId" UserSourceName="FillByInstructorId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CourseInstructorId, CourseId, UserId FROM dbo.CourseInstructors
where UserId = @userId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.CourseInstructors" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertCourseInstructor" Modifier="Public" Name="InsertCourseInstructor" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertCourseInstructor">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[CourseInstructors] ([CourseId], [UserId]) VALUES (@CourseId, @UserId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.CourseInstructors" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.CourseInstructors" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AnnouncementsTableAdapter" GeneratorDataComponentClassName="AnnouncementsTableAdapter" Name="Announcements" UserDataComponentName="AnnouncementsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Announcements" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Announcements] WHERE (([AnnouncementId] = @Original_AnnouncementId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AnnouncementId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnouncementId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Announcements] ([CourseId], [Subject], [Announcement], [AnnouncementDate]) VALUES (@CourseId, @Subject, @Announcement, @AnnouncementDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Subject" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Announcement" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Announcement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AnnouncementDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AnnouncementDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT AnnouncementId, CourseId, Subject, Announcement, AnnouncementDate FROM dbo.Announcements</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Announcements] SET [CourseId] = @CourseId, [Subject] = @Subject, [Announcement] = @Announcement, [AnnouncementDate] = @AnnouncementDate WHERE (([AnnouncementId] = @Original_AnnouncementId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Subject" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Announcement" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Announcement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@AnnouncementDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="AnnouncementDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AnnouncementId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AnnouncementId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AnnouncementId" DataSetColumn="AnnouncementId" />
              <Mapping SourceColumn="CourseId" DataSetColumn="CourseId" />
              <Mapping SourceColumn="Subject" DataSetColumn="Subject" />
              <Mapping SourceColumn="Announcement" DataSetColumn="Announcement" />
              <Mapping SourceColumn="AnnouncementDate" DataSetColumn="AnnouncementDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteAnnouncement" Modifier="Public" Name="DeleteAnnouncement" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteAnnouncement">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[Announcements] WHERE (([AnnouncementId] = @announcementId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="announcementId" ColumnName="AnnouncementId" DataSourceName="METUCMTDB.dbo.Announcements" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@announcementId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AnnouncementId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Announcements" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCourseId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCourseId" GeneratorSourceName="FillByCourseId" GetMethodModifier="Public" GetMethodName="GetDataByCourseId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCourseId" UserSourceName="FillByCourseId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AnnouncementId, CourseId, Subject, Announcement, AnnouncementDate FROM dbo.Announcements
where CourseId = @courseId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.Announcements" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.InsertAnnouncement" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="InsertAnnouncement" Modifier="Public" Name="InsertAnnouncement" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertAnnouncement">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.InsertAnnouncement</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Subject" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Announcement" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@AnnouncementDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="InputOutput" ParameterName="@Identity" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateAnnouncement" Modifier="Public" Name="UpdateAnnouncement" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateAnnouncement">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Announcements] SET [CourseId] = @CourseId, [Subject] = @Subject, [Announcement] = @Announcement WHERE (([AnnouncementId] = @announcementId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.Announcements" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Subject" ColumnName="Subject" DataSourceName="METUCMTDB.dbo.Announcements" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@Subject" Precision="0" ProviderType="VarChar" Scale="0" Size="40" SourceColumn="Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Announcement" ColumnName="Announcement" DataSourceName="METUCMTDB.dbo.Announcements" DataTypeServer="nvarchar(250)" DbType="String" Direction="Input" ParameterName="@Announcement" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumn="Announcement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="announcementId" ColumnName="AnnouncementId" DataSourceName="METUCMTDB.dbo.Announcements" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@announcementId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AnnouncementId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LectureNotesTableAdapter" GeneratorDataComponentClassName="LectureNotesTableAdapter" Name="LectureNotes" UserDataComponentName="LectureNotesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.LectureNotes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[LectureNotes] WHERE (([NoteId] = @Original_NoteId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NoteId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoteId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[LectureNotes] ([SystemNoteName], [NoteName], [UploadTime], [CourseId]) VALUES (@SystemNoteName, @NoteName, @UploadTime, @CourseId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SystemNoteName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SystemNoteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NoteName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UploadTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UploadTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT NoteId, SystemNoteName, NoteName, UploadTime, CourseId FROM dbo.LectureNotes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[LectureNotes] SET [SystemNoteName] = @SystemNoteName, [NoteName] = @NoteName, [UploadTime] = @UploadTime, [CourseId] = @CourseId WHERE (([NoteId] = @Original_NoteId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SystemNoteName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SystemNoteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NoteName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NoteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UploadTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UploadTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NoteId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NoteId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="NoteId" DataSetColumn="NoteId" />
              <Mapping SourceColumn="SystemNoteName" DataSetColumn="SystemNoteName" />
              <Mapping SourceColumn="NoteName" DataSetColumn="NoteName" />
              <Mapping SourceColumn="UploadTime" DataSetColumn="UploadTime" />
              <Mapping SourceColumn="CourseId" DataSetColumn="CourseId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteLectureNote" Modifier="Public" Name="DeleteLectureNote" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteLectureNote">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[LectureNotes] WHERE (([NoteId] = @noteId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="noteId" ColumnName="NoteId" DataSourceName="METUCMTDB.dbo.LectureNotes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@noteId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="NoteId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.LectureNotes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCourseId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCourseId" GeneratorSourceName="FillByCourseId" GetMethodModifier="Public" GetMethodName="GetDataByCourseId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCourseId" UserSourceName="FillByCourseId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT NoteId, SystemNoteName, NoteName, UploadTime, CourseId FROM dbo.LectureNotes
where CourseId = @courseId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.LectureNotes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertLectureNote" Modifier="Public" Name="InsertLectureNote" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertLectureNote">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[LectureNotes] ([SystemNoteName], [NoteName], [UploadTime], [CourseId]) VALUES (@SystemNoteName, @NoteName, @UploadTime, @CourseId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SystemNoteName" ColumnName="SystemNoteName" DataSourceName="METUCMTDB.dbo.LectureNotes" DataTypeServer="nvarchar(150)" DbType="String" Direction="Input" ParameterName="@SystemNoteName" Precision="0" ProviderType="NVarChar" Scale="0" Size="150" SourceColumn="SystemNoteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="NoteName" ColumnName="NoteName" DataSourceName="METUCMTDB.dbo.LectureNotes" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@NoteName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="NoteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UploadTime" ColumnName="UploadTime" DataSourceName="METUCMTDB.dbo.LectureNotes" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@UploadTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="UploadTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.LectureNotes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Users] WHERE (([UserId] = @Original_UserId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Users] ([UserName], [Password], [Role], [AdminFlag], [Name], [Surname], [EMail], [PhotoId], [ExpiryDate]) VALUES (@UserName, @Password, @Role, @AdminFlag, @Name, @Surname, @EMail, @PhotoId, @ExpiryDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdminFlag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdminFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhotoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhotoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpiryDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserId, UserName, Password, Role, AdminFlag, Name, Surname, EMail, PhotoId, ExpiryDate FROM dbo.Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Users] SET [UserName] = @UserName, [Password] = @Password, [Role] = @Role, [AdminFlag] = @AdminFlag, [Name] = @Name, [Surname] = @Surname, [EMail] = @EMail, [PhotoId] = @PhotoId, [ExpiryDate] = @ExpiryDate WHERE (([UserId] = @Original_UserId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdminFlag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdminFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhotoId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhotoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpiryDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
              <Mapping SourceColumn="AdminFlag" DataSetColumn="AdminFlag" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="EMail" DataSetColumn="EMail" />
              <Mapping SourceColumn="PhotoId" DataSetColumn="PhotoId" />
              <Mapping SourceColumn="ExpiryDate" DataSetColumn="ExpiryDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPasswordRecovery" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPasswordRecovery" GeneratorSourceName="FillByPasswordRecovery" GetMethodModifier="Public" GetMethodName="GetDataByPasswordRecovery" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPasswordRecovery" UserSourceName="FillByPasswordRecovery">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM dbo.Users where UserName=@username and EMail=@email</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="UserName" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="email" ColumnName="EMail" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByRole" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByRole" GeneratorSourceName="FillByRole" GetMethodModifier="Public" GetMethodName="GetDataByRole" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByRole" UserSourceName="FillByRole">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT UserId, UserName, Password, Role, AdminFlag, Name, Surname, EMail, PhotoId, ExpiryDate FROM dbo.Users
where Role = @role</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="role" ColumnName="Role" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@role" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserId" GeneratorSourceName="FillByUserId" GetMethodModifier="Public" GetMethodName="GetDataByUserId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserId" UserSourceName="FillByUserId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT UserId, UserName, Password, Role, AdminFlag, Name, Surname, EMail, PhotoId, ExpiryDate FROM dbo.Users
where UserId = @userId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserName" GeneratorSourceName="FillByUserName" GetMethodModifier="Public" GetMethodName="GetDataByUserName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserName" UserSourceName="FillByUserName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT UserId, UserName, Password, Role, AdminFlag, Name, Surname, EMail, PhotoId, ExpiryDate FROM dbo.Users
where UserName = @userName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userName" ColumnName="UserName" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@userName" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertUser" Modifier="Public" Name="InsertUser" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertUser">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[Users] ([UserName], [Password], [Role], [AdminFlag], [Name], [Surname], [EMail], [PhotoId], [ExpiryDate]) VALUES (@UserName, @Password, @Role, @AdminFlag, @Name, @Surname, @EMail, @PhotoId, @ExpiryDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserName" ColumnName="UserName" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Password" ColumnName="Password" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Role" ColumnName="Role" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AdminFlag" ColumnName="AdminFlag" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AdminFlag" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdminFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(25)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="25" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Surname" ColumnName="Surname" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(25)" DbType="AnsiString" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="VarChar" Scale="0" Size="25" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="EMail" ColumnName="EMail" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PhotoId" ColumnName="PhotoId" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PhotoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PhotoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ExpiryDate" ColumnName="ExpiryDate" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ExpiryDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdatePassword" Modifier="Public" Name="UpdatePassword" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdatePassword">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Users] SET [Password] = @Password WHERE (([UserId] = @Original_UserId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Password" ColumnName="Password" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_UserId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateUser" Modifier="Public" Name="UpdateUser" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateUser">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Users] SET [UserName] = @UserName, [Name] = @Name, [Surname] = @Surname, [EMail] = @EMail, [ExpiryDate] = @ExpiryDate WHERE (([UserId] = @userId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserName" ColumnName="UserName" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(25)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="25" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Surname" ColumnName="Surname" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(25)" DbType="AnsiString" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="VarChar" Scale="0" Size="25" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="EMail" ColumnName="EMail" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ExpiryDate" ColumnName="ExpiryDate" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ExpiryDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ExpiryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="userId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateUserPhoto" Modifier="Public" Name="UpdateUserPhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdateUserPhoto">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Users] SET [PhotoId] = @PhotoId WHERE (([UserId] = @Original_UserId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PhotoId" ColumnName="PhotoId" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PhotoId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PhotoId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_UserId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateUserSelf" Modifier="Public" Name="UpdateUserSelf" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="UpdateUserSelf">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Users] SET [UserName] = @UserName, [EMail] = @EMail WHERE (([UserId] = @Original_UserId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserName" ColumnName="UserName" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="EMail" ColumnName="EMail" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@EMail" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="EMail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_UserId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TeamsTableAdapter" GeneratorDataComponentClassName="TeamsTableAdapter" Name="Teams" UserDataComponentName="TeamsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Teams" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Teams] WHERE (([TeamId] = @Original_TeamId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Teams] ([CourseId], [TeamName], [TeamLogo]) VALUES (@CourseId, @TeamName, @TeamLogo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TeamName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TeamName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TeamLogo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TeamLogo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TeamId, CourseId, TeamName, TeamLogo FROM dbo.Teams</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Teams] SET [CourseId] = @CourseId, [TeamName] = @TeamName, [TeamLogo] = @TeamLogo WHERE (([TeamId] = @Original_TeamId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TeamName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TeamName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TeamLogo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TeamLogo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TeamId" DataSetColumn="TeamId" />
              <Mapping SourceColumn="CourseId" DataSetColumn="CourseId" />
              <Mapping SourceColumn="TeamName" DataSetColumn="TeamName" />
              <Mapping SourceColumn="TeamLogo" DataSetColumn="TeamLogo" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteTeam" Modifier="Public" Name="DeleteTeam" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteTeam">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[Teams] WHERE (([TeamId] = @TeamId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TeamId" ColumnName="TeamId" DataSourceName="METUCMTDB.dbo.Teams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Teams" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCourseId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCourseId" GeneratorSourceName="FillByCourseId" GetMethodModifier="Public" GetMethodName="GetDataByCourseId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCourseId" UserSourceName="FillByCourseId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CourseId, TeamId, TeamLogo, TeamName FROM Teams WHERE (CourseId = @courseId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.Teams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Teams" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTeamId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTeamId" GeneratorSourceName="FillByTeamId" GetMethodModifier="Public" GetMethodName="GetDataByTeamId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTeamId" UserSourceName="FillByTeamId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TeamId, CourseId, TeamName, TeamLogo FROM dbo.Teams
where TeamId = @teamId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="teamId" ColumnName="TeamId" DataSourceName="METUCMTDB.dbo.Teams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@teamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertTeam" Modifier="Public" Name="InsertTeam" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertTeam">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[Teams] ([CourseId], [TeamName], [TeamLogo]) VALUES (@CourseId, @TeamName, @TeamLogo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.Teams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TeamName" ColumnName="TeamName" DataSourceName="METUCMTDB.dbo.Teams" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@TeamName" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="TeamName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TeamLogo" ColumnName="TeamLogo" DataSourceName="METUCMTDB.dbo.Teams" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@TeamLogo" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="TeamLogo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TeamMembersTableAdapter" GeneratorDataComponentClassName="TeamMembersTableAdapter" Name="TeamMembers" UserDataComponentName="TeamMembersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.TeamMembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TeamMembers] WHERE (([TeamMemberId] = @Original_TeamMemberId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TeamMemberId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeamMemberId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TeamMembers] ([TeamId], [UserId]) VALUES (@TeamId, @UserId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TeamMemberId, TeamId, UserId FROM dbo.TeamMembers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TeamMembers] SET [TeamId] = @TeamId, [UserId] = @UserId WHERE (([TeamMemberId] = @Original_TeamMemberId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TeamMemberId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeamMemberId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TeamMemberId" DataSetColumn="TeamMemberId" />
              <Mapping SourceColumn="TeamId" DataSetColumn="TeamId" />
              <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteTeamMember" Modifier="Public" Name="DeleteTeamMember" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteTeamMember">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[TeamMembers] WHERE
TeamId = @teamId and UserId = @userId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="teamId" ColumnName="TeamId" DataSourceName="METUCMTDB.dbo.TeamMembers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@teamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="userId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.TeamMembers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.TeamMembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTeamId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTeamId" GeneratorSourceName="FillByTeamId" GetMethodModifier="Public" GetMethodName="GetDataByTeamId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTeamId" UserSourceName="FillByTeamId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TeamMemberId, TeamId, UserId FROM dbo.TeamMembers
where TeamId = @teamId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="teamId" ColumnName="TeamId" DataSourceName="METUCMTDB.dbo.TeamMembers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@teamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertTeamMember" Modifier="Public" Name="InsertTeamMember" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertTeamMember">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[TeamMembers] ([TeamId], [UserId]) VALUES (@TeamId, @UserId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TeamId" ColumnName="TeamId" DataSourceName="METUCMTDB.dbo.TeamMembers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="UserId" ColumnName="UserId" DataSourceName="METUCMTDB.dbo.TeamMembers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReviewTeamsTableAdapter" GeneratorDataComponentClassName="ReviewTeamsTableAdapter" Name="ReviewTeams" UserDataComponentName="ReviewTeamsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.ReviewTeams" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ReviewTeams] WHERE (([ReviewTeamId] = @Original_ReviewTeamId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReviewTeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReviewTeamId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ReviewTeams] ([EventId], [RevievedTeamId], [RevieverTeamId]) VALUES (@EventId, @RevievedTeamId, @RevieverTeamId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RevievedTeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RevievedTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RevieverTeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RevieverTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ReviewTeamId, EventId, RevievedTeamId, RevieverTeamId FROM dbo.ReviewTeams</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ReviewTeams] SET [EventId] = @EventId, [RevievedTeamId] = @RevievedTeamId, [RevieverTeamId] = @RevieverTeamId WHERE (([ReviewTeamId] = @Original_ReviewTeamId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RevievedTeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RevievedTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RevieverTeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RevieverTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReviewTeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReviewTeamId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReviewTeamId" DataSetColumn="ReviewTeamId" />
              <Mapping SourceColumn="EventId" DataSetColumn="EventId" />
              <Mapping SourceColumn="RevievedTeamId" DataSetColumn="RevievedTeamId" />
              <Mapping SourceColumn="RevieverTeamId" DataSetColumn="RevieverTeamId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteReviewTeam" Modifier="Public" Name="DeleteReviewTeam" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteReviewTeam">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[ReviewTeams] WHERE (([ReviewTeamId] = @Original_ReviewTeamId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ReviewTeamId" ColumnName="ReviewTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ReviewTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ReviewTeamId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.ReviewTeams" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByEventId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByEventId" GeneratorSourceName="FillByEventId" GetMethodModifier="Public" GetMethodName="GetDataByEventId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByEventId" UserSourceName="FillByEventId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ReviewTeamId, EventId, RevievedTeamId, RevieverTeamId FROM dbo.ReviewTeams
where EventId = @eventId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="eventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@eventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.ReviewTeams" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByRevievedTeamId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByRevievedTeamId" GeneratorSourceName="FillByRevievedTeamId" GetMethodModifier="Public" GetMethodName="GetDataByRevievedTeamId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByRevievedTeamId" UserSourceName="FillByRevievedTeamId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ReviewTeamId, EventId, RevievedTeamId, RevieverTeamId FROM dbo.ReviewTeams
where RevievedTeamId = @reviewedTeamId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="reviewedTeamId" ColumnName="RevievedTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@reviewedTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RevievedTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.ReviewTeams" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByRevieverTeamId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByRevieverTeamId" GeneratorSourceName="FillByRevieverTeamId" GetMethodModifier="Public" GetMethodName="GetDataByRevieverTeamId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByRevieverTeamId" UserSourceName="FillByRevieverTeamId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ReviewTeamId, EventId, RevievedTeamId, RevieverTeamId FROM dbo.ReviewTeams
where RevieverTeamId = @revieverTeamId </CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="revieverTeamId" ColumnName="RevieverTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@revieverTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RevieverTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.ReviewTeams" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByReviewTeamId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByReviewTeamId" GeneratorSourceName="FillByReviewTeamId" GetMethodModifier="Public" GetMethodName="GetDataByReviewTeamId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByReviewTeamId" UserSourceName="FillByReviewTeamId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ReviewTeamId, EventId, RevievedTeamId, RevieverTeamId FROM dbo.ReviewTeams
where ReviewTeamId = @reviewTeamId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="reviewTeamId" ColumnName="ReviewTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@reviewTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ReviewTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertReviewTeam" Modifier="Public" Name="InsertReviewTeam" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertReviewTeam">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[ReviewTeams] ([EventId], [RevievedTeamId], [RevieverTeamId]) VALUES (@EventId, @RevievedTeamId, @RevieverTeamId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="EventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="RevievedTeamId" ColumnName="RevievedTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RevievedTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RevievedTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="RevieverTeamId" ColumnName="RevieverTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RevieverTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RevieverTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateReviewTeam" Modifier="Public" Name="UpdateReviewTeam" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateReviewTeam">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[ReviewTeams] SET [EventId] = @EventId, [RevievedTeamId] = @RevievedTeamId, [RevieverTeamId] = @RevieverTeamId WHERE (([ReviewTeamId] = @Original_ReviewTeamId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="EventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="RevievedTeamId" ColumnName="RevievedTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RevievedTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RevievedTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="RevieverTeamId" ColumnName="RevieverTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RevieverTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RevieverTeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ReviewTeamId" ColumnName="ReviewTeamId" DataSourceName="METUCMTDB.dbo.ReviewTeams" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ReviewTeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ReviewTeamId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImagesTableAdapter" GeneratorDataComponentClassName="ImagesTableAdapter" Name="Images" UserDataComponentName="ImagesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Images" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Images] WHERE (([ImageId] = @Original_ImageId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ImageId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ImageId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Images] ([ImageData]) VALUES (@ImageData)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ImageData" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ImageId, ImageData FROM dbo.Images</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Images] SET [ImageData] = @ImageData WHERE (([ImageId] = @Original_ImageId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ImageData" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ImageId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ImageId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ImageId" DataSetColumn="ImageId" />
              <Mapping SourceColumn="ImageData" DataSetColumn="ImageData" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteImage" Modifier="Public" Name="DeleteImage" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteImage">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[Images] WHERE (([ImageId] = @Original_ImageId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ImageId" ColumnName="ImageId" DataSourceName="METUCMTDB.dbo.Images" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ImageId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ImageId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Images" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByImageData" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByImageData" GeneratorSourceName="FillByImageData" GetMethodModifier="Public" GetMethodName="GetDataByImageData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByImageData" UserSourceName="FillByImageData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ImageId FROM dbo.Images where ImageData=@imageData</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="imageData" ColumnName="ImageData" DataSourceName="METUCMTDB.dbo.Images" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@imageData" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Images" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByImageId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByImageId" GeneratorSourceName="FillByImageId" GetMethodModifier="Public" GetMethodName="GetDataByImageId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByImageId" UserSourceName="FillByImageId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ImageData FROM dbo.Images where ImageId=@imageId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="imageId" ColumnName="ImageId" DataSourceName="METUCMTDB.dbo.Images" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@imageId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ImageId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertImage" Modifier="Public" Name="InsertImage" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertImage">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[Images] ([ImageData]) VALUES (@ImageData)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ImageData" ColumnName="ImageData" DataSourceName="METUCMTDB.dbo.Images" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@ImageData" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateImage" Modifier="Public" Name="UpdateImage" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateImage">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Images] SET [ImageData] = @ImageData WHERE (([ImageId] = @Original_ImageId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ImageData" ColumnName="ImageData" DataSourceName="METUCMTDB.dbo.Images" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@ImageData" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ImageId" ColumnName="ImageId" DataSourceName="METUCMTDB.dbo.Images" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_ImageId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ImageId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseStudentTableAdapter" GeneratorDataComponentClassName="CourseStudentTableAdapter" Name="CourseStudent" UserDataComponentName="CourseStudentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.CourseStudent" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CourseStudent] ([CourseId], [StudentId]) VALUES (@CourseId, @StudentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StudentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CourseStudentId, CourseId, StudentId FROM dbo.CourseStudent</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CourseStudentId" DataSetColumn="CourseStudentId" />
              <Mapping SourceColumn="CourseId" DataSetColumn="CourseId" />
              <Mapping SourceColumn="StudentId" DataSetColumn="StudentId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteCourseStudent" Modifier="Public" Name="DeleteCourseStudent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteCourseStudent">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE from CourseStudent
where CourseId = @courseId and StudentId = @studentId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.CourseStudent" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="studentId" ColumnName="StudentId" DataSourceName="METUCMTDB.dbo.CourseStudent" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@studentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StudentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.CourseStudent" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCourseId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCourseId" GeneratorSourceName="FillByCourseId" GetMethodModifier="Public" GetMethodName="GetDataByCourseId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCourseId" UserSourceName="FillByCourseId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CourseStudentId, CourseId, StudentId FROM dbo.CourseStudent
where CourseId = @courseId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="courseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.CourseStudent" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.CourseStudent" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByStudentId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByStudentId" GeneratorSourceName="FillByStudentId" GetMethodModifier="Public" GetMethodName="GetDataByStudentId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByStudentId" UserSourceName="FillByStudentId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CourseStudentId, CourseId, StudentId FROM dbo.CourseStudent
where StudentId = @studentId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="studentId" ColumnName="StudentId" DataSourceName="METUCMTDB.dbo.CourseStudent" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@studentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StudentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertCourseStudent" Modifier="Public" Name="InsertCourseStudent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertCourseStudent">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[CourseStudent] ([CourseId], [StudentId]) VALUES (@CourseId, @StudentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseId" ColumnName="CourseId" DataSourceName="METUCMTDB.dbo.CourseStudent" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StudentId" ColumnName="StudentId" DataSourceName="METUCMTDB.dbo.CourseStudent" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StudentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StudentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DocumentsTableAdapter" GeneratorDataComponentClassName="DocumentsTableAdapter" Name="Documents" UserDataComponentName="DocumentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Documents" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Documents] WHERE (([DocumentId] = @Original_DocumentId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DocumentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocumentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Documents] ([EventId], [TeamId], [DocType], [UploadTime], [DocLink], [UploaderId]) VALUES (@EventId, @TeamId, @DocType, @UploadTime, @DocLink, @UploaderId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DocType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DocType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UploadTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UploadTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DocLink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DocLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UploaderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UploaderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT DocumentId, EventId, TeamId, DocType, UploadTime, DocLink, UploaderId FROM dbo.Documents</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Documents] SET [EventId] = @EventId, [TeamId] = @TeamId, [DocType] = @DocType, [UploadTime] = @UploadTime, [DocLink] = @DocLink, [UploaderId] = @UploaderId WHERE (([DocumentId] = @Original_DocumentId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TeamId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DocType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DocType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@UploadTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="UploadTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DocLink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DocLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UploaderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UploaderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DocumentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocumentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DocumentId" DataSetColumn="DocumentId" />
              <Mapping SourceColumn="EventId" DataSetColumn="EventId" />
              <Mapping SourceColumn="TeamId" DataSetColumn="TeamId" />
              <Mapping SourceColumn="DocType" DataSetColumn="DocType" />
              <Mapping SourceColumn="UploadTime" DataSetColumn="UploadTime" />
              <Mapping SourceColumn="DocLink" DataSetColumn="DocLink" />
              <Mapping SourceColumn="UploaderId" DataSetColumn="UploaderId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteDocument" Modifier="Public" Name="DeleteDocument" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteDocument">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[Documents] WHERE (([DocumentId] = @Original_DocumentId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_DocumentId" ColumnName="DocumentId" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_DocumentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocumentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Documents" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByEventId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByEventId" GeneratorSourceName="FillByEventId" GetMethodModifier="Public" GetMethodName="GetDataByEventId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByEventId" UserSourceName="FillByEventId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DocumentId, EventId, TeamId, DocType, UploadTime, DocLink, UploaderId FROM dbo.Documents
where EventId = @eventId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="eventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@eventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Documents" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTeamId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTeamId" GeneratorSourceName="FillByTeamId" GetMethodModifier="Public" GetMethodName="GetDataByTeamId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTeamId" UserSourceName="FillByTeamId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DocumentId, EventId, TeamId, DocType, UploadTime, DocLink, UploaderId FROM dbo.Documents
where TeamId = @teamId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="teamId" ColumnName="TeamId" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@teamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertDocument" Modifier="Public" Name="InsertDocument" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertDocument">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[Documents] ([EventId], [TeamId], [DocType], [UploadTime], [DocLink], [UploaderId]) VALUES (@EventId, @TeamId, @DocType, @UploadTime, @DocLink, @UploaderId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="EventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TeamId" ColumnName="TeamId" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TeamId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TeamId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DocType" ColumnName="DocType" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@DocType" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="DocType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="UploadTime" ColumnName="UploadTime" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@UploadTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="UploadTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DocLink" ColumnName="DocLink" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@DocLink" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="DocLink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UploaderId" ColumnName="UploaderId" DataSourceName="METUCMTDB.dbo.Documents" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UploaderId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UploaderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PermissionsTableAdapter" GeneratorDataComponentClassName="PermissionsTableAdapter" Name="Permissions" UserDataComponentName="PermissionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Permissions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Permissions] ([Url], [Role]) VALUES (@Url, @Role)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Url" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Url" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Url, Role FROM dbo.Permissions</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Url" DataSetColumn="Url" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Permissions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserName" GeneratorSourceName="FillByUserName" GetMethodModifier="Public" GetMethodName="GetDataByUserName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserName" UserSourceName="FillByUserName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Url, Role FROM dbo.Permissions
where Role = (select top 1 Role from Users where UserName = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="username" ColumnName="" DataSourceName="" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" Scale="0" Size="10" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EventsTableAdapter" GeneratorDataComponentClassName="EventsTableAdapter" Name="Events" UserDataComponentName="EventsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Events" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Events] WHERE (([EventId] = @Original_EventId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Events] ([ScheduleId], [DueDate], [Description], [SubmissionRequiredFlag], [MailState]) VALUES (@ScheduleId, @DueDate, @Description, @SubmissionRequiredFlag, @MailState)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ScheduleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScheduleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SubmissionRequiredFlag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubmissionRequiredFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MailState" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MailState" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EventId, ScheduleId, DueDate, Description, SubmissionRequiredFlag, MailState FROM dbo.Events</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Events] SET [ScheduleId] = @ScheduleId, [DueDate] = @DueDate, [Description] = @Description, [SubmissionRequiredFlag] = @SubmissionRequiredFlag, [MailState] = @MailState WHERE (([EventId] = @Original_EventId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ScheduleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScheduleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SubmissionRequiredFlag" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubmissionRequiredFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MailState" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MailState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EventId" DataSetColumn="EventId" />
              <Mapping SourceColumn="ScheduleId" DataSetColumn="ScheduleId" />
              <Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="SubmissionRequiredFlag" DataSetColumn="SubmissionRequiredFlag" />
              <Mapping SourceColumn="MailState" DataSetColumn="MailState" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteEvent" Modifier="Public" Name="DeleteEvent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteEvent">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[Events] WHERE (([EventId] = @Original_EventId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Events" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCourseId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCourseId" GeneratorSourceName="FillByCourseId" GetMethodModifier="Public" GetMethodName="GetDataByCourseId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCourseId" UserSourceName="FillByCourseId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT EventId, ScheduleId, DueDate, Description, SubmissionRequiredFlag, MailState FROM dbo.Events
where ScheduleId = @courseId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="courseId" ColumnName="ScheduleId" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@courseId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ScheduleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="METUCMTDB.dbo.Events" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByEventId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByEventId" GeneratorSourceName="FillByEventId" GetMethodModifier="Public" GetMethodName="GetDataByEventId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByEventId" UserSourceName="FillByEventId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT EventId, ScheduleId, DueDate, Description, SubmissionRequiredFlag, MailState FROM dbo.Events
where EventId = @eventId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="eventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@eventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="IncrementMailState" Modifier="Public" Name="IncrementMailState" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="IncrementMailState">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Events] SET [MailState] = [MailState] + 1 WHERE (([EventId] = @Original_EventId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertEvent" Modifier="Public" Name="InsertEvent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="InsertEvent">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[Events] ([ScheduleId], [DueDate], [Description], [SubmissionRequiredFlag], [MailState]) VALUES (@ScheduleId, @DueDate, @Description, @SubmissionRequiredFlag, 0)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ScheduleId" ColumnName="ScheduleId" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ScheduleId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ScheduleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DueDate" ColumnName="DueDate" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Description" ColumnName="Description" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SubmissionRequiredFlag" ColumnName="SubmissionRequiredFlag" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SubmissionRequiredFlag" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SubmissionRequiredFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="METUCMTDBConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateEvent" Modifier="Public" Name="UpdateEvent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdateEvent">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE [dbo].[Events] SET [ScheduleId] = @ScheduleId, [DueDate] = @DueDate, [Description] = @Description, [SubmissionRequiredFlag] = @SubmissionRequiredFlag WHERE (([EventId] = @Original_EventId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ScheduleId" ColumnName="ScheduleId" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ScheduleId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ScheduleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DueDate" ColumnName="DueDate" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Description" ColumnName="Description" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SubmissionRequiredFlag" ColumnName="SubmissionRequiredFlag" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SubmissionRequiredFlag" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SubmissionRequiredFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_EventId" ColumnName="EventId" DataSourceName="METUCMTDB.dbo.Events" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_EventId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EventId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="METUCMTDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="METUCMTDataSet" msprop:Generator_UserDSName="METUCMTDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Courses" msprop:Generator_TableClassName="CoursesDataTable" msprop:Generator_TableVarName="tableCourses" msprop:Generator_TablePropName="Courses" msprop:Generator_RowDeletingName="CoursesRowDeleting" msprop:Generator_UserTableName="Courses" msprop:Generator_RowChangingName="CoursesRowChanging" msprop:Generator_RowEvHandlerName="CoursesRowChangeEventHandler" msprop:Generator_RowDeletedName="CoursesRowDeleted" msprop:Generator_RowEvArgName="CoursesRowChangeEvent" msprop:Generator_RowChangedName="CoursesRowChanged" msprop:Generator_RowClassName="CoursesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CourseId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCourseId" msprop:Generator_ColumnPropNameInRow="CourseId" msprop:Generator_ColumnPropNameInTable="CourseIdColumn" msprop:Generator_UserColumnName="CourseId" type="xs:int" />
              <xs:element name="CourseCode" msprop:Generator_ColumnVarNameInTable="columnCourseCode" msprop:Generator_ColumnPropNameInRow="CourseCode" msprop:Generator_ColumnPropNameInTable="CourseCodeColumn" msprop:Generator_UserColumnName="CourseCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CourseName" msprop:Generator_ColumnVarNameInTable="columnCourseName" msprop:Generator_ColumnPropNameInRow="CourseName" msprop:Generator_ColumnPropNameInTable="CourseNameColumn" msprop:Generator_UserColumnName="CourseName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Semester" msprop:Generator_ColumnVarNameInTable="columnSemester" msprop:Generator_ColumnPropNameInRow="Semester" msprop:Generator_ColumnPropNameInTable="SemesterColumn" msprop:Generator_UserColumnName="Semester" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CourseInstructors" msprop:Generator_TableClassName="CourseInstructorsDataTable" msprop:Generator_TableVarName="tableCourseInstructors" msprop:Generator_TablePropName="CourseInstructors" msprop:Generator_RowDeletingName="CourseInstructorsRowDeleting" msprop:Generator_UserTableName="CourseInstructors" msprop:Generator_RowChangingName="CourseInstructorsRowChanging" msprop:Generator_RowEvHandlerName="CourseInstructorsRowChangeEventHandler" msprop:Generator_RowDeletedName="CourseInstructorsRowDeleted" msprop:Generator_RowEvArgName="CourseInstructorsRowChangeEvent" msprop:Generator_RowChangedName="CourseInstructorsRowChanged" msprop:Generator_RowClassName="CourseInstructorsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CourseInstructorId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCourseInstructorId" msprop:Generator_ColumnPropNameInRow="CourseInstructorId" msprop:Generator_ColumnPropNameInTable="CourseInstructorIdColumn" msprop:Generator_UserColumnName="CourseInstructorId" type="xs:int" />
              <xs:element name="CourseId" msprop:Generator_ColumnVarNameInTable="columnCourseId" msprop:Generator_ColumnPropNameInRow="CourseId" msprop:Generator_ColumnPropNameInTable="CourseIdColumn" msprop:Generator_UserColumnName="CourseId" type="xs:int" />
              <xs:element name="UserId" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" msprop:Generator_UserColumnName="UserId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Announcements" msprop:Generator_TableClassName="AnnouncementsDataTable" msprop:Generator_TableVarName="tableAnnouncements" msprop:Generator_TablePropName="Announcements" msprop:Generator_RowDeletingName="AnnouncementsRowDeleting" msprop:Generator_UserTableName="Announcements" msprop:Generator_RowChangingName="AnnouncementsRowChanging" msprop:Generator_RowEvHandlerName="AnnouncementsRowChangeEventHandler" msprop:Generator_RowDeletedName="AnnouncementsRowDeleted" msprop:Generator_RowEvArgName="AnnouncementsRowChangeEvent" msprop:Generator_RowChangedName="AnnouncementsRowChanged" msprop:Generator_RowClassName="AnnouncementsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AnnouncementId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnAnnouncementId" msprop:Generator_ColumnPropNameInRow="AnnouncementId" msprop:Generator_ColumnPropNameInTable="AnnouncementIdColumn" msprop:Generator_UserColumnName="AnnouncementId" type="xs:int" />
              <xs:element name="CourseId" msprop:Generator_ColumnVarNameInTable="columnCourseId" msprop:Generator_ColumnPropNameInRow="CourseId" msprop:Generator_ColumnPropNameInTable="CourseIdColumn" msprop:Generator_UserColumnName="CourseId" type="xs:int" />
              <xs:element name="Subject" msprop:Generator_ColumnVarNameInTable="columnSubject" msprop:Generator_ColumnPropNameInRow="Subject" msprop:Generator_ColumnPropNameInTable="SubjectColumn" msprop:Generator_UserColumnName="Subject">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Announcement" msprop:Generator_ColumnVarNameInTable="columnAnnouncement" msprop:Generator_ColumnPropNameInRow="Announcement" msprop:Generator_ColumnPropNameInTable="AnnouncementColumn" msprop:Generator_UserColumnName="Announcement">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AnnouncementDate" msprop:Generator_ColumnVarNameInTable="columnAnnouncementDate" msprop:Generator_ColumnPropNameInRow="AnnouncementDate" msprop:Generator_ColumnPropNameInTable="AnnouncementDateColumn" msprop:Generator_UserColumnName="AnnouncementDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LectureNotes" msprop:Generator_TableClassName="LectureNotesDataTable" msprop:Generator_TableVarName="tableLectureNotes" msprop:Generator_TablePropName="LectureNotes" msprop:Generator_RowDeletingName="LectureNotesRowDeleting" msprop:Generator_UserTableName="LectureNotes" msprop:Generator_RowChangingName="LectureNotesRowChanging" msprop:Generator_RowEvHandlerName="LectureNotesRowChangeEventHandler" msprop:Generator_RowDeletedName="LectureNotesRowDeleted" msprop:Generator_RowEvArgName="LectureNotesRowChangeEvent" msprop:Generator_RowChangedName="LectureNotesRowChanged" msprop:Generator_RowClassName="LectureNotesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="NoteId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnNoteId" msprop:Generator_ColumnPropNameInRow="NoteId" msprop:Generator_ColumnPropNameInTable="NoteIdColumn" msprop:Generator_UserColumnName="NoteId" type="xs:int" />
              <xs:element name="SystemNoteName" msprop:Generator_ColumnVarNameInTable="columnSystemNoteName" msprop:Generator_ColumnPropNameInRow="SystemNoteName" msprop:Generator_ColumnPropNameInTable="SystemNoteNameColumn" msprop:Generator_UserColumnName="SystemNoteName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NoteName" msprop:Generator_ColumnVarNameInTable="columnNoteName" msprop:Generator_ColumnPropNameInRow="NoteName" msprop:Generator_ColumnPropNameInTable="NoteNameColumn" msprop:Generator_UserColumnName="NoteName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UploadTime" msprop:Generator_ColumnVarNameInTable="columnUploadTime" msprop:Generator_ColumnPropNameInRow="UploadTime" msprop:Generator_ColumnPropNameInTable="UploadTimeColumn" msprop:Generator_UserColumnName="UploadTime" type="xs:dateTime" />
              <xs:element name="CourseId" msprop:Generator_ColumnVarNameInTable="columnCourseId" msprop:Generator_ColumnPropNameInRow="CourseId" msprop:Generator_ColumnPropNameInTable="CourseIdColumn" msprop:Generator_UserColumnName="CourseId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" msprop:Generator_UserColumnName="UserId" type="xs:int" />
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Role" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_UserColumnName="Role" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdminFlag" msprop:Generator_ColumnVarNameInTable="columnAdminFlag" msprop:Generator_ColumnPropNameInRow="AdminFlag" msprop:Generator_ColumnPropNameInTable="AdminFlagColumn" msprop:Generator_UserColumnName="AdminFlag" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_UserColumnName="Surname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EMail" msprop:Generator_ColumnVarNameInTable="columnEMail" msprop:Generator_ColumnPropNameInRow="EMail" msprop:Generator_ColumnPropNameInTable="EMailColumn" msprop:Generator_UserColumnName="EMail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhotoId" msprop:Generator_ColumnVarNameInTable="columnPhotoId" msprop:Generator_ColumnPropNameInRow="PhotoId" msprop:Generator_ColumnPropNameInTable="PhotoIdColumn" msprop:Generator_UserColumnName="PhotoId" type="xs:int" minOccurs="0" />
              <xs:element name="ExpiryDate" msprop:Generator_ColumnVarNameInTable="columnExpiryDate" msprop:Generator_ColumnPropNameInRow="ExpiryDate" msprop:Generator_ColumnPropNameInTable="ExpiryDateColumn" msprop:Generator_UserColumnName="ExpiryDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Teams" msprop:Generator_TableClassName="TeamsDataTable" msprop:Generator_TableVarName="tableTeams" msprop:Generator_TablePropName="Teams" msprop:Generator_RowDeletingName="TeamsRowDeleting" msprop:Generator_UserTableName="Teams" msprop:Generator_RowChangingName="TeamsRowChanging" msprop:Generator_RowEvHandlerName="TeamsRowChangeEventHandler" msprop:Generator_RowDeletedName="TeamsRowDeleted" msprop:Generator_RowEvArgName="TeamsRowChangeEvent" msprop:Generator_RowChangedName="TeamsRowChanged" msprop:Generator_RowClassName="TeamsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TeamId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTeamId" msprop:Generator_ColumnPropNameInRow="TeamId" msprop:Generator_ColumnPropNameInTable="TeamIdColumn" msprop:Generator_UserColumnName="TeamId" type="xs:int" />
              <xs:element name="CourseId" msprop:Generator_ColumnVarNameInTable="columnCourseId" msprop:Generator_ColumnPropNameInRow="CourseId" msprop:Generator_ColumnPropNameInTable="CourseIdColumn" msprop:Generator_UserColumnName="CourseId" type="xs:int" />
              <xs:element name="TeamName" msprop:Generator_ColumnVarNameInTable="columnTeamName" msprop:Generator_ColumnPropNameInRow="TeamName" msprop:Generator_ColumnPropNameInTable="TeamNameColumn" msprop:Generator_UserColumnName="TeamName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TeamLogo" msprop:Generator_ColumnVarNameInTable="columnTeamLogo" msprop:Generator_ColumnPropNameInRow="TeamLogo" msprop:Generator_ColumnPropNameInTable="TeamLogoColumn" msprop:Generator_UserColumnName="TeamLogo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TeamMembers" msprop:Generator_TableClassName="TeamMembersDataTable" msprop:Generator_TableVarName="tableTeamMembers" msprop:Generator_TablePropName="TeamMembers" msprop:Generator_RowDeletingName="TeamMembersRowDeleting" msprop:Generator_UserTableName="TeamMembers" msprop:Generator_RowChangingName="TeamMembersRowChanging" msprop:Generator_RowEvHandlerName="TeamMembersRowChangeEventHandler" msprop:Generator_RowDeletedName="TeamMembersRowDeleted" msprop:Generator_RowEvArgName="TeamMembersRowChangeEvent" msprop:Generator_RowChangedName="TeamMembersRowChanged" msprop:Generator_RowClassName="TeamMembersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TeamMemberId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTeamMemberId" msprop:Generator_ColumnPropNameInRow="TeamMemberId" msprop:Generator_ColumnPropNameInTable="TeamMemberIdColumn" msprop:Generator_UserColumnName="TeamMemberId" type="xs:int" />
              <xs:element name="TeamId" msprop:Generator_ColumnVarNameInTable="columnTeamId" msprop:Generator_ColumnPropNameInRow="TeamId" msprop:Generator_ColumnPropNameInTable="TeamIdColumn" msprop:Generator_UserColumnName="TeamId" type="xs:int" />
              <xs:element name="UserId" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" msprop:Generator_UserColumnName="UserId" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReviewTeams" msprop:Generator_TableClassName="ReviewTeamsDataTable" msprop:Generator_TableVarName="tableReviewTeams" msprop:Generator_TablePropName="ReviewTeams" msprop:Generator_RowDeletingName="ReviewTeamsRowDeleting" msprop:Generator_UserTableName="ReviewTeams" msprop:Generator_RowChangingName="ReviewTeamsRowChanging" msprop:Generator_RowEvHandlerName="ReviewTeamsRowChangeEventHandler" msprop:Generator_RowDeletedName="ReviewTeamsRowDeleted" msprop:Generator_RowEvArgName="ReviewTeamsRowChangeEvent" msprop:Generator_RowChangedName="ReviewTeamsRowChanged" msprop:Generator_RowClassName="ReviewTeamsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReviewTeamId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnReviewTeamId" msprop:Generator_ColumnPropNameInRow="ReviewTeamId" msprop:Generator_ColumnPropNameInTable="ReviewTeamIdColumn" msprop:Generator_UserColumnName="ReviewTeamId" type="xs:int" />
              <xs:element name="EventId" msprop:Generator_ColumnVarNameInTable="columnEventId" msprop:Generator_ColumnPropNameInRow="EventId" msprop:Generator_ColumnPropNameInTable="EventIdColumn" msprop:Generator_UserColumnName="EventId" type="xs:int" />
              <xs:element name="RevievedTeamId" msprop:Generator_ColumnVarNameInTable="columnRevievedTeamId" msprop:Generator_ColumnPropNameInRow="RevievedTeamId" msprop:Generator_ColumnPropNameInTable="RevievedTeamIdColumn" msprop:Generator_UserColumnName="RevievedTeamId" type="xs:int" minOccurs="0" />
              <xs:element name="RevieverTeamId" msprop:Generator_ColumnVarNameInTable="columnRevieverTeamId" msprop:Generator_ColumnPropNameInRow="RevieverTeamId" msprop:Generator_ColumnPropNameInTable="RevieverTeamIdColumn" msprop:Generator_UserColumnName="RevieverTeamId" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Images" msprop:Generator_TableClassName="ImagesDataTable" msprop:Generator_TableVarName="tableImages" msprop:Generator_TablePropName="Images" msprop:Generator_RowDeletingName="ImagesRowDeleting" msprop:Generator_UserTableName="Images" msprop:Generator_RowChangingName="ImagesRowChanging" msprop:Generator_RowEvHandlerName="ImagesRowChangeEventHandler" msprop:Generator_RowDeletedName="ImagesRowDeleted" msprop:Generator_RowEvArgName="ImagesRowChangeEvent" msprop:Generator_RowChangedName="ImagesRowChanged" msprop:Generator_RowClassName="ImagesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ImageId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnImageId" msprop:Generator_ColumnPropNameInRow="ImageId" msprop:Generator_ColumnPropNameInTable="ImageIdColumn" msprop:Generator_UserColumnName="ImageId" type="xs:int" />
              <xs:element name="ImageData" msprop:Generator_ColumnVarNameInTable="columnImageData" msprop:Generator_ColumnPropNameInRow="ImageData" msprop:Generator_ColumnPropNameInTable="ImageDataColumn" msprop:Generator_UserColumnName="ImageData" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CourseStudent" msprop:Generator_TableClassName="CourseStudentDataTable" msprop:Generator_TableVarName="tableCourseStudent" msprop:Generator_TablePropName="CourseStudent" msprop:Generator_RowDeletingName="CourseStudentRowDeleting" msprop:Generator_UserTableName="CourseStudent" msprop:Generator_RowChangingName="CourseStudentRowChanging" msprop:Generator_RowEvHandlerName="CourseStudentRowChangeEventHandler" msprop:Generator_RowDeletedName="CourseStudentRowDeleted" msprop:Generator_RowEvArgName="CourseStudentRowChangeEvent" msprop:Generator_RowChangedName="CourseStudentRowChanged" msprop:Generator_RowClassName="CourseStudentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CourseStudentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCourseStudentId" msprop:Generator_ColumnPropNameInRow="CourseStudentId" msprop:Generator_ColumnPropNameInTable="CourseStudentIdColumn" msprop:Generator_UserColumnName="CourseStudentId" type="xs:int" />
              <xs:element name="CourseId" msprop:Generator_ColumnVarNameInTable="columnCourseId" msprop:Generator_ColumnPropNameInRow="CourseId" msprop:Generator_ColumnPropNameInTable="CourseIdColumn" msprop:Generator_UserColumnName="CourseId" type="xs:int" />
              <xs:element name="StudentId" msprop:Generator_ColumnVarNameInTable="columnStudentId" msprop:Generator_ColumnPropNameInRow="StudentId" msprop:Generator_ColumnPropNameInTable="StudentIdColumn" msprop:Generator_UserColumnName="StudentId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Documents" msprop:Generator_TableClassName="DocumentsDataTable" msprop:Generator_TableVarName="tableDocuments" msprop:Generator_TablePropName="Documents" msprop:Generator_RowDeletingName="DocumentsRowDeleting" msprop:Generator_UserTableName="Documents" msprop:Generator_RowChangingName="DocumentsRowChanging" msprop:Generator_RowEvHandlerName="DocumentsRowChangeEventHandler" msprop:Generator_RowDeletedName="DocumentsRowDeleted" msprop:Generator_RowEvArgName="DocumentsRowChangeEvent" msprop:Generator_RowChangedName="DocumentsRowChanged" msprop:Generator_RowClassName="DocumentsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DocumentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnDocumentId" msprop:Generator_ColumnPropNameInRow="DocumentId" msprop:Generator_ColumnPropNameInTable="DocumentIdColumn" msprop:Generator_UserColumnName="DocumentId" type="xs:int" />
              <xs:element name="EventId" msprop:Generator_ColumnVarNameInTable="columnEventId" msprop:Generator_ColumnPropNameInRow="EventId" msprop:Generator_ColumnPropNameInTable="EventIdColumn" msprop:Generator_UserColumnName="EventId" type="xs:int" minOccurs="0" />
              <xs:element name="TeamId" msprop:Generator_ColumnVarNameInTable="columnTeamId" msprop:Generator_ColumnPropNameInRow="TeamId" msprop:Generator_ColumnPropNameInTable="TeamIdColumn" msprop:Generator_UserColumnName="TeamId" type="xs:int" minOccurs="0" />
              <xs:element name="DocType" msprop:Generator_ColumnVarNameInTable="columnDocType" msprop:Generator_ColumnPropNameInRow="DocType" msprop:Generator_ColumnPropNameInTable="DocTypeColumn" msprop:Generator_UserColumnName="DocType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UploadTime" msprop:Generator_ColumnVarNameInTable="columnUploadTime" msprop:Generator_ColumnPropNameInRow="UploadTime" msprop:Generator_ColumnPropNameInTable="UploadTimeColumn" msprop:Generator_UserColumnName="UploadTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DocLink" msprop:Generator_ColumnVarNameInTable="columnDocLink" msprop:Generator_ColumnPropNameInRow="DocLink" msprop:Generator_ColumnPropNameInTable="DocLinkColumn" msprop:Generator_UserColumnName="DocLink" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UploaderId" msprop:Generator_ColumnVarNameInTable="columnUploaderId" msprop:Generator_ColumnPropNameInRow="UploaderId" msprop:Generator_ColumnPropNameInTable="UploaderIdColumn" msprop:Generator_UserColumnName="UploaderId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Permissions" msprop:Generator_TableClassName="PermissionsDataTable" msprop:Generator_TableVarName="tablePermissions" msprop:Generator_TablePropName="Permissions" msprop:Generator_RowDeletingName="PermissionsRowDeleting" msprop:Generator_UserTableName="Permissions" msprop:Generator_RowChangingName="PermissionsRowChanging" msprop:Generator_RowEvHandlerName="PermissionsRowChangeEventHandler" msprop:Generator_RowDeletedName="PermissionsRowDeleted" msprop:Generator_RowEvArgName="PermissionsRowChangeEvent" msprop:Generator_RowChangedName="PermissionsRowChanged" msprop:Generator_RowClassName="PermissionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Url" msprop:Generator_ColumnVarNameInTable="columnUrl" msprop:Generator_ColumnPropNameInRow="Url" msprop:Generator_ColumnPropNameInTable="UrlColumn" msprop:Generator_UserColumnName="Url">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Role" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_UserColumnName="Role">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Events" msprop:Generator_TableClassName="EventsDataTable" msprop:Generator_TableVarName="tableEvents" msprop:Generator_TablePropName="Events" msprop:Generator_RowDeletingName="EventsRowDeleting" msprop:Generator_UserTableName="Events" msprop:Generator_RowChangingName="EventsRowChanging" msprop:Generator_RowEvHandlerName="EventsRowChangeEventHandler" msprop:Generator_RowDeletedName="EventsRowDeleted" msprop:Generator_RowEvArgName="EventsRowChangeEvent" msprop:Generator_RowChangedName="EventsRowChanged" msprop:Generator_RowClassName="EventsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EventId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnEventId" msprop:Generator_ColumnPropNameInRow="EventId" msprop:Generator_ColumnPropNameInTable="EventIdColumn" msprop:Generator_UserColumnName="EventId" type="xs:int" />
              <xs:element name="ScheduleId" msprop:Generator_ColumnVarNameInTable="columnScheduleId" msprop:Generator_ColumnPropNameInRow="ScheduleId" msprop:Generator_ColumnPropNameInTable="ScheduleIdColumn" msprop:Generator_UserColumnName="ScheduleId" type="xs:int" minOccurs="0" />
              <xs:element name="DueDate" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" msprop:Generator_UserColumnName="DueDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SubmissionRequiredFlag" msprop:Generator_ColumnVarNameInTable="columnSubmissionRequiredFlag" msprop:Generator_ColumnPropNameInRow="SubmissionRequiredFlag" msprop:Generator_ColumnPropNameInTable="SubmissionRequiredFlagColumn" msprop:Generator_UserColumnName="SubmissionRequiredFlag" type="xs:int" minOccurs="0" />
              <xs:element name="MailState" msprop:Generator_ColumnVarNameInTable="columnMailState" msprop:Generator_ColumnPropNameInRow="MailState" msprop:Generator_ColumnPropNameInTable="MailStateColumn" msprop:Generator_UserColumnName="MailState" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Courses" />
      <xs:field xpath="mstns:CourseId" />
    </xs:unique>
    <xs:unique name="CourseInstructors_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CourseInstructors" />
      <xs:field xpath="mstns:CourseInstructorId" />
    </xs:unique>
    <xs:unique name="Announcements_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Announcements" />
      <xs:field xpath="mstns:AnnouncementId" />
    </xs:unique>
    <xs:unique name="LectureNotes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LectureNotes" />
      <xs:field xpath="mstns:NoteId" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:UserId" />
    </xs:unique>
    <xs:unique name="Teams_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Teams" />
      <xs:field xpath="mstns:TeamId" />
    </xs:unique>
    <xs:unique name="TeamMembers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TeamMembers" />
      <xs:field xpath="mstns:TeamMemberId" />
    </xs:unique>
    <xs:unique name="ReviewTeams_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ReviewTeams" />
      <xs:field xpath="mstns:ReviewTeamId" />
    </xs:unique>
    <xs:unique name="Images_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Images" />
      <xs:field xpath="mstns:ImageId" />
    </xs:unique>
    <xs:unique name="Documents_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Documents" />
      <xs:field xpath="mstns:DocumentId" />
    </xs:unique>
    <xs:unique name="Events_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Events" />
      <xs:field xpath="mstns:EventId" />
    </xs:unique>
  </xs:element>
</xs:schema>